First N – Head

Returns the first specified number of elements in a set, while retaining duplicates.

  ______________________________________________________________________

Create query with:

 

·           Place next level State Province in Row area

·           Place measure MarkUp in Data area

 

 

Now to get only first five (5) members:

 

·           Select Dimension Function for hierarchy Customer.hCountry

·           Select function First N

 

  NOTE: When you have only one dimension on axis it is absolutely the same if you

                          use Axis, Dimension or Element function.

                          However, whenever possible use Dimension functions.

 

 

 

Dialog will appear:

 

 

·           Change value of 100 to 5

·           Select OK

·           Select Run

 

 

First five members are at the table.